LOAD DATA 
 INFILE LOTES.dat
 TRUNCATE
 CONTINUEIF NEXT(1:1) = '#'
 INTO TABLE LOTES
 FIELDS TERMINATED BY '|'
 TRAILING NULLCOLS (
   ID_LOTE,
   DIRECION 	NULLIF DIRECION = BLANKS,
   AREA 	NULLIF AREA = BLANKS,
   DES_ECONOM 	NULLIF DES_ECONOM = BLANKS,
   ID_PREDIO,
   Shape_Leng,
   Shape_Area,
   GEO COLUMN OBJECT 
   (
     SDO_GTYPE       INTEGER EXTERNAL, 
     SDO_ELEM_INFO   VARRAY TERMINATED BY '|/' 
       (X            FLOAT EXTERNAL), 
     SDO_ORDINATES   VARRAY TERMINATED BY '|/' 
       (X            FLOAT EXTERNAL) 
   )
)
